Limitations for global transformations

The following limitations apply to global transformations:

Transformations are not supported for columns with Right-to-Left languages.
Transformations cannot be performed on columns that contain special characters (e.g. #, \, /, -) in their name.
The only supported transformation for columns that are mapped to BLOB/CLOB data types (by Replicate) is to drop the column on the target.
Expressions must be written using SQLite syntax only.
Changing a global transformation value will not reload affected tables automatically. The target must be reloaded manually for the changes to take effect.

For information on reloading the target, see Using the Run button options.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!